This appendix contains sample Check Reconciliation reports.
Date 05/21/2019 Time 11:59:38 XYZ Company Report #0113 Page 0001
C H E C K I N G A C C O U N T S L I S T
Starting Checking Account: “First” Ending Checking Account: “Last”
------------------------------------------------------------------------------------------------------------------------------------
Checking-account-# Bank name Bank-acct-# Lst-chk-date Checkbook-balance
Description Address-1 Contact Lst-stmnt-date Lst-stmnt-balance
Address-2 Phone
Address-3 Recon-method
------------------------------------------------------------------------------------------------------------------------------------
1000-000 First National Bank 125-6992 12,557.40-
Cash account #13557 Corporate Teller Paul Jeffries .00
27 Main Street 555-123-4567
Bigtown, Texas 12345 Book-to-bank
1010-000 New Point Bank 21111-0005 .00
Cash account #13726 3500 West Street Mr. Jones .00
Suite 45 800-455-9000
Concord, NH 03302 Bank-to-book
-- End of report --
Date 03/21/2019 Time 12:28:55 XYZ Company Report #0116 Page 0001
C H E C K B O O K L I S T
For dates: “Earliest” thru “Latest”
All checking accounts selected
------------------------------------------------------------------------------------------------------------------------------------
Date Type Doc-# Payee Name or comment Amount Clear-date Status
------------------------------------------------------------------------------------------------------------------------------------
Checking account: 1000-000 Cash account #13557 Bank acct #: 125-6992
01/01/19 Deposit 3947 Sample deposit 100.00
03/15/19 Bal forwrd 3/15 statement balance 9,051.91 03/15/19 Cleared
-- End of report --
Date 05/21/2019 Time 12:52:04 XYZ Company Report #0117 Page 0001
C H E C K B O O K E N T R I E S R E G I S T E R
------------------------------------------------------------------------------------------------------------------------------------
Checking-acct Bank-acct-# Date Type Doc-# Payee Name or comment Amount
Description
------------------------------------------------------------------------------------------------------------------------------------
1000-000 125-6992 3/21/19 Check 991 Robertson Enterprises 123.00
Cash account #13557
Distributions: 2000-000 Accounts payable 123.00
3/21/19 Check 992 Huckins Supply 84.00
Distributions: 2000-000 Accounts payable 84.00
3/25/19 Deposit 993 8,000.00
Distributions: 1020-000 Cash account #13591 8,000.00
3/25/19 Check 994 Leavitt Delivery Services 47.00
Distributions: 2000-000 Accounts payable 47.00
3 checks: 254.00 1 deposits: 8,000.00 0 adjust.: .00
Date 05/21/2019 Time 12:52:04 XYZ Company Report #0117 Page 0002
C H E C K B O O K E N T R I E S R E G I S T E R
------------------------------------------------------------------------------------------------------------------------------------
Checking-acct Bank-acct-# Date Type Doc-# Payee Name or comment Amount
Description
------------------------------------------------------------------------------------------------------------------------------------
1010-000 21111-0005 3/21/19 Check 1001 Huckins Supply 97.00
Cash account #13726
Distributions: 2000-000 Accounts payable 97.00
1 checks: 97.00 0 deposits: .00 0 adjust.: .00
Date 05/21/2019 Time 12:52:04 XYZ Company Report #0117 Page 0003
C H E C K B O O K E N T R I E S R E G I S T E R
------------------------------------------------------------------------------------------------------------------------------------
Checking-acct Bank-acct-# Date Type Doc-# Payee Name or comment Amount
Description
------------------------------------------------------------------------------------------------------------------------------------
Grand totals: 4 checks: 351.00 1 deposits: 8,000.00 0 adjust.: .00
Acct-# Description Debits Credits
Distribution summary: 1000-000 Cash account #13557 8,000.00 254.00
1010-000 Cash account #13726 .00 97.00
1020-000 Cash account #13591 .00 8,000.00
2000-000 Accounts payable 351.00 .00
----------------------------------
Totals: 8,351.00 8,351.00
-- End of report --
Date 05/21/2019 Time 13:54:30 XYZ Company Report #0119 Page 0001
R E C O N C I L I A T I O N R E P O R T
Checking account: 1000-000 Cash account #13557 Reconciliation method: Book-to-Bank
Bank acct #: 125-6992
Statement date: 4/15/19 Cut-off date for uncleared entries: 4/15/19
------------------------------------------------------------------------------------------------------------------------------------
Date Type Doc-# Payee Name or comment Deposit/CR Check/DR Reconciled
------------------------------------------------------------------------------------------------------------------------------------
1/01/19 Deposit 3947 Sample deposit 100.00
3/21/19 Check 991 Robertson Enterprises 123.00
3/21/19 Check 992 Huckins Supply 84.00
3/25/19 Deposit 993 8,000.00
3/25/19 Check 994 Leavitt Delivery Services 47.00
-- End of report --
Date 05/21/2019 Time 13:56:16 XYZ Company Report #0120 Page 0001
C H E C K B O O K R E P O R T
Checking account: 1000-000 Cash account #13557
Bank acct #: 125-6992
Date range: “Earliest” thru “Latest”
------------------------------------------------------------------------------------------------------------------------------------
Date Type Doc-# Payee Name or comment Deposit/CR Check/DR Balance
------------------------------------------------------------------------------------------------------------------------------------
** STARTING BALANCE ** 0.00
1/01/19 Deposit 3947 Sample deposit 100.00 100.00
3/15/19 Bal fwd 3/15 statement balance 9,051.91 9,151.91
3/21/19 Check 991 Robertson Enterprises 123.00 9,028.91
3/21/19 Check 992 Huckins Supply 84.00 8,944.91
3/25/19 Deposit 993 8,000.00 16,944.91
3/25/19 Check 994 Leavitt Delivery Services 47.00 16,897.91
** ENDING BALANCE ** 16,897.91
Entries shown: 1 Balance forwards
2 Deposits
3 Checks
0 Adjustments
-- End of report --
Date 05/21/2019 Time 15:07:25 XYZ Company Report #0121 Page 0001
A C C O U N T A C T I V I T Y R E P O R T
For dates: “Earliest” thru “Latest”
Sources are: A/R = Accounts Receivable A/P = Accounts Payable PR = Payroll DIRECT = Direct entry
“Changed” after the Source means that the amount has been changed after the entry was transferred.
------------------------------------------------------------------------------------------------------------------------------------
Date Type Doc-# Payee Name or comment Amount Clear-date Status Source
------------------------------------------------------------------------------------------------------------------------------------
Checking account: 1000-000 Cash account #13557 Bank acct #: 125-6992
1/01/19 Deposit 3947 Sample deposit 100.00 DIRECT
3/15/19 Bal forwrd 3/15 statement balance 9,051.91 3/15/19 Cleared DIRECT
3/21/19 Check 991 Robertson Enterprises 123.00- DIRECT
3/21/19 Check 992 Huckins Supply 84.00- DIRECT
3/25/19 Deposit 993 8,000.00 DIRECT
3/25/19 Check 994 Leavitt Delivery Services 47.00- DIRECT
Total balance forward: 9,051.91
Total checks: 254.00-
Total deposits: 8,100.00
Total adjustments: .00
Net change: 16,897.91
-- End of report --
Checkbook Distributions to General Ledger report
Date 05/21/2019 Time 15:18:21 XYZ Company Report #0122 Page 0001
C H E C K B O O K D I S T R I B U T I O N S T O G E N E R A L L E D G E R R E P O R T
Starting account #: “First” Ending account #: “Last”
Starting date: 03/01/19 Ending date: “Latest”
Journal codes: CR = Checkbook entries journal
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description
Date Jrnl-# Amount Payee/Comment Doc-#
------------------------------------------------------------------------------------------------------------------------------------
Cash section
1000-000 Cash account #13557
03/21/19 CR0117 123.00CR Robertson Enterprises 991
CR0117 84.00CR Huckins Supply 992
Date total: 207.00CR
03/25/19 CR0117 8,000.00 993
CR0117 47.00CR Leavitt Delivery Services 994
Date total: 7,953.00
Account total: 7,746.00
1010-000 Cash account #13726
03/21/19 CR0117 97.00CR Huckins Supply 1001
Date total: 97.00CR
Account total: 97.00CR
Section total: 7,649.00
Date 05/21/2019 Time 15:18:21 XYZ Company Report #0122 Page 0002
C H E C K B O O K D I S T R I B U T I O N S T O G E N E R A L L E D G E R R E P O R T
Starting account #: “First” Ending account #: “Last”
Starting date: 03/01/19 Ending date: “Latest”
Journal codes: CR = Checkbook entries journal
------------------------------------------------------------------------------------------------------------------------------------
Acct-# Description
Date Jrnl-# Amount Payee/Comment Doc-#
------------------------------------------------------------------------------------------------------------------------------------
Income & Expenses section
1020-000 Cash account #13591
03/25/19 CR0117 8,000.00CR 993
Date total: 8,000.00CR
Account total: 8,000.00CR
2000-000 Accounts payable
03/21/19 CR0117 123.00 Robertson Enterprises 991
CR0117 84.00 Huckins Supply 992
CR0117 97.00 Huckins Supply 1001
Date total: 304.00
03/25/19 CR0117 47.00 Leavitt Delivery Services 994
Date total: 47.00
Account total: 351.00
Section total: 7,649.00CR
Report total: .00
-- End of report --
Compress Cleared Entries Report
Date 05/21/2019 Time 15:25:25 XYZ Company Report #0124 Page 0001
C O M P R E S S C L E A R E D E N T R I E S R E P O R T
Checking account: 1000-000 Cash account #13557
Bank account #: 125-6992
Cut-off date: 4/15/19
------------------------------------------------------------------------------------------------------------------------------------
Date Type Doc-# Payee Name or comment Deposit/CR Check/DR Clear-date
------------------------------------------------------------------------------------------------------------------------------------
The following records:
1/01/19 Deposit 3947 Sample deposit 100.00 4/15/19
2/21/19 Deposit 3434 55.89 4/15/19
3/15/19 Bal forwrd 3/15 statement balance 9,051.91 3/15/19
3/21/19 Check 991 Robertson Enterprises 123.00 4/15/19
3/21/19 Check 992 Huckins Supply 84.00 4/15/19
3/25/19 Deposit 993 8,000.00 4/15/19
Have been compressed into:
3/25/19 Bal forwrd ****************************************** 17,000.80 3/25/19
------------------------------------------------------------------------------------------------------------------------------------
-- End of report --